IMG
Loading..
Select a color
Duro Poplin 65% Poly/35% Cotton Women's Long Sleeve Shirt
Item: 8FL-126R54
Brand: Flying Cross

Oppps.. This color is currently out-of stock, Please contact us for availablitiy.

QTY:
List Price:
This women’s duro poplin long sleeve shirt is made using a mixture of 65% polyester and 35% cotton. It features IntelliDry technology with a natural stretch, deep dye technology, and exceptional wrinkle resistance. This women’s public safety shirt is ideal for officers in any kind of environment. The shirt absorbs perspiration, repels liquids, and releases stains when it’s washed. It offers five sewn-in creases with two in the front and three in the back, includes a badge sling, and offers a hidden pen or pencil compartment in the left breast pocket for convenience.
SELECT `I`.`ListID`, `I`.`ProductID`, `I`.`ItemGroup`, `I`.`ItemColorID`, `I`.`ItemColor`, `I`.`ItemSizeOnly` AS `ItemSize`, `I`.`ItemLength`, `I`.`RequiredAlterationID`, `I`.`ProspectItem`, MAX(`S`.CatID) AS CatID, `I`.`SalesPrice`,`I`.`SalesPrice` AS `WebPrice`, `I`.`AltShowListID`, `I`.`InventoryOnly` FROM `tbl_items` `I` LEFT JOIN `tbl_items_search` `S` ON (`I`.`ItemID`=`S`.`ItemID`) AND (`S`.`CatID` = '2076') WHERE (`I`.`ItemGroup` = '8FL-126R54') AND (`I`.`ShowOnlyLocal` = '1') AND (`I`.`IsActive` != '0') AND (`I`.`SpecialGroupID` Is Null OR `I`.`SpecialGroupID` = '0') GROUP BY `I`.`ListID` ORDER BY `I`.`ProspectItem`, IFNULL(`I`.`ItemColor`,'ZZZZZZ'),`I`.`SizeSort`,`I`.`ItemSize`, `I`.`ItemLength`